Hệ thống quản lý trường học bằng PHP / MySQLi
1
2 <?php
3 error_reporting(0);
4 include('connect.php');
5 if (isset($_POST['register'])){
6
7 $asset_code=$_POST['asset_code'];
8 $date_purchased=$_POST['date_purchased'];
9 $estimated_value=$_POST['estimated_value'];
10 $location=$_POST['location'];
11 $mode_make=$_POST['mode_make'];
12 $purchase_price=$_POST['purchase_price'];
13 $serial_number=$_POST['serial_number'];
14 $asset_condition=$_POST['asset_condition'];
15 $quantity=$_POST['quantity'];
16 $order_number=$_POST['order_number'];
17 $active=$_POST['active'];
18 $reason_for_disposing=$_POST['reason_for_disposing'];
19 $updated_by=$_POST['updated_by'];
20
21
22 $sql="UPDATE inventory SET asset_code='$asset_code',
23 date_purchased='$date_purchased',
24 estimated_value='$estimated_value',
25 location='$location',
26 mode_make='$mode_make',
27 purchase_price='$purchase_price',
28 serial_number='$serial_number',
29 asset_condition='$asset_condition',
30 quantity='$quantity',
31 order_number='$order_number',
32 active='$active',
33 reason_for_disposing='$reason_for_disposing',
34 updated_by='$updated_by'
35 WHERE asset_code='$asset_code'" ;
36
37
38 mysqli_query($db,$sql);
39
40 ?>
41 <?php
42
43 $query="SELECT * FROM inventory WHERE asset_code='$asset_code'";
44 $records2=mysqli_query($db,$query);
45 while($rec=mysqli_fetch_array($records2))
46 {
47 $id = $rec['asset_id'];
48 }?>
49
50 <script>
51 alert('Record Succsessfully Updated');
52 window.location = "view_inventory.php?id=<?php echo $id;?>";
53 </script>
54
55 <?php
56
57 }?>